[dbo].[BAECartItemInsert]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartItemInsert

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@UserID	varchar(64)	64
@ItemType	varchar(64)	64
@Created	datetime	8
@LastUpdated	datetime	8

SQL Script

create procedure [dbo].[BAECartItemInsert] @UserID as
varchar(64),
    @ItemType AS varchar(64),
    @Created AS datetime,
    @LastUpdated AS datetime
AS
    INSERT INTO CartItem
    (UserID,
     ItemType,
     Created,
     LastUpdated)
    VALUES
    (@UserID,
    @ItemType,
    @Created,
    @LastUpdated);

SELECT CAST(@@IDENTITY AS int) AS 'Identity';

GO

Uses

[dbo].[CartItem]
dbo